﻿<%@ Page Title="" Language="VB" MasterPageFile="~/Library/Reportes.master" AutoEventWireup="false"
    CodeFile="RPTEdXCursoActual.aspx.vb" Inherits="Reportes_RPTEdXCursoActual" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server">
    <style type="text/css">
        .AlineacionDerecha
        {
            text-align: right;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="Server">
   <asp:ScriptManager 
            ID="ScriptManager1" runat="server">
        </asp:ScriptManager> 
        <h1>
        Personas mayores de 15 y menores de 60 años que recibe algun curso (Educación informal)
    </h1>
    (para descargar las imagenes haga clic derecho sobre la imagen y luego haga clic en guardar como, se recomienda usar 
    <a href="http://www.mozilla.com/es-ES/firefox/">firefox</a> o 
    <a href="http://windows.microsoft.com/es-ES/internet-explorer/products/ie/home">Internet Explorer</a>)
        <asp:UpdatePanel ID="UpdatePanel1" runat="server">
    <ContentTemplate >

    <table>
        <tr>
            <th colspan="2">
                Opciones de filtro
            </th>
        </tr>
        <tr>
            <td>
                Proyecto
            </td>
            <td>
                <asp:DropDownList ID="ddlProyectos" runat="server" AutoPostBack="true" >
                </asp:DropDownList>
            </td>
        </tr>
        <tr>
            <td>
                Departamento
            </td>
            <td>
                <asp:DropDownList ID="ddlDepto" runat="server" AutoPostBack="true">
                </asp:DropDownList>
            </td>
        </tr>
        <tr>
            <td>
                Municipio
            </td>
            <td>
                <asp:DropDownList ID="ddlMunicipio" runat="server">
                </asp:DropDownList>
            </td>
        </tr>
        <tr>
            <td>
                Localizacion
            </td>
            <td>
                <asp:DropDownList ID="ddlLocalizacion" runat="server">
                </asp:DropDownList>
            </td>
        </tr>

        <tr>
            <td>
                Visita
            </td>
            <td>
                <asp:DropDownList ID="ddlVisita" runat="server">
                </asp:DropDownList>
            </td>
        </tr>

        <tr>
            <td>
                <b>Discapacidad</b>
            </td>
            <td>
                <asp:DropDownList ID="ddlDiscapacidad" runat="server">
                <asp:ListItem Value = '0'>Con y sin discapacidad</asp:ListItem>
                <asp:ListItem Value = 'Si'>Con discapacidad</asp:ListItem>
                <asp:ListItem Value = 'No'>Sin discapacidad</asp:ListItem>
                </asp:DropDownList>
            </td>
        </tr>
     </table>
    </ContentTemplate>
    </asp:UpdatePanel>
    <table>        
        <tr>
            <td colspan="2" class="botones">
                <asp:Button ID="btnConsultar" runat="server" Text="Ver reporte" CssClass="boton" />
                <asp:Button ID="btnExp" runat="server" Text="Exportar a excel" CssClass="boton" />
            </td>
        </tr>
    </table>
    <table>
        <tr>
            <td colspan="2">
               <h2> Distribución por sexo </h2>
                <table>
                <tr>
                <td valign="top">
                
                <asp:GridView ID="grdResultado" runat="server" AutoGenerateColumns="false">
                    <Columns>
                        <asp:BoundField DataField="Detalle" HeaderText="Sexo" />
                        <asp:BoundField DataField="cantidad" HeaderText="Cantidad" DataFormatString="{0:N0}">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>
                        <asp:BoundField DataField="P" HeaderText="%" DataFormatString="{0:P2}">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>
                    </Columns>
                </asp:GridView>
                </td>
                <td valign="top">
                <asp:Chart ID="Chart1" runat="server" Palette="BrightPastel" BackColor="#F3DFC1"
                    Width="412px" Height="296px" BorderlineDashStyle="Solid" BackGradientStyle="TopBottom"
                    BorderWidth="2" BorderColor="181, 64, 1">
                    <Titles>
                        <asp:Title ShadowColor="32, 0, 0, 0" Font="Trebuchet MS, 12.25pt, style=Bold" ShadowOffset="3"
                            Name="Title1" ForeColor="26, 59, 105">
                        </asp:Title>
                    </Titles>
                    <Legends>
                        <asp:Legend TitleFont="Microsoft Sans Serif, 8pt, style=Bold" BackColor="Transparent"
                            Font="Trebuchet MS, 8.25pt, style=Bold" IsTextAutoFit="False" Enabled="False"
                            Name="Default">
                        </asp:Legend>
                    </Legends>
                    <BorderSkin SkinStyle="Emboss"></BorderSkin>
                    <Series>
                        <asp:Series Name="Default">
                        </asp:Series>
                    </Series>
                    <ChartAreas>
                        <asp:ChartArea Name="ChartArea1" BorderColor="64, 64, 64, 64" BackSecondaryColor="White"
                            BackColor="OldLace" ShadowColor="Transparent" BackGradientStyle="TopBottom">
                            <Area3DStyle Rotation="10" Perspective="10" Inclination="15" IsRightAngleAxes="False"
                                WallWidth="0" IsClustered="False" />
                            <AxisY LineColor="64, 64, 64, 64" LabelAutoFitMaxFontSize="8">
                                <LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" Format="C0" />
                                <MajorGrid LineColor="64, 64, 64, 64" />
                            </AxisY>
                            <AxisX LineColor="64, 64, 64, 64" LabelAutoFitMaxFontSize="8">
                                <LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" IsEndLabelVisible="False" Format="MM-dd" />
                                <MajorGrid LineColor="64, 64, 64, 64" />
                            </AxisX>
                        </asp:ChartArea>
                    </ChartAreas>
                </asp:Chart>
                <asp:RadioButtonList runat = "Server" ID="rbTipoGrafica1" AutoPostBack="True" RepeatDirection=Horizontal >
                    <asp:ListItem Text="Columnas" Value="10" Selected="True"  />
                    <asp:ListItem Text="Barras" Value="7"/>
                    <asp:ListItem Text="Circular" Value="17"/>
                    <asp:ListItem Text="Linea" Value="3"/>                
                </asp:RadioButtonList>
                </td>
                </tr>
                </table>
                
            </td>
        </tr>
        
        
        
        <tr>
            <td colspan="2">
               <h2> Personas que reciben algun curso (Educación informal) <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label></h2>
                <table>
                <tr>
                <td valign="top">
                <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
                    <Columns>
                        <asp:BoundField DataField="Recibe curso" HeaderText="Detalle" />
                        <asp:BoundField DataField="mujeres" HeaderText="Mujeres" DataFormatString="{0:N0}">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>
                        <asp:BoundField DataField="mujeresp" HeaderText="%" DataFormatString="{0:P2}">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>
                        <asp:BoundField DataField="hombres" HeaderText="Hombres" DataFormatString="{0:N0}">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>
                        <asp:BoundField DataField="hombresp" HeaderText="%" DataFormatString="{0:P2}">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>
                        <asp:BoundField DataField="Total" HeaderText="Total" DataFormatString="{0:N0}">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>
                        <asp:BoundField DataField="Totalp" HeaderText="%" DataFormatString="{0:P2}">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>

                    </Columns>
                </asp:GridView>
                </td>
                <td valign="top">
                <asp:Chart ID="Chart2" runat="server" Palette="BrightPastel" BackColor="#F3DFC1"
                    Width="412px" Height="296px" BorderlineDashStyle="Solid" BackGradientStyle="TopBottom"
                    BorderWidth="2" BorderColor="181, 64, 1">
                    <Titles>
                        <asp:Title ShadowColor="32, 0, 0, 0" Font="Trebuchet MS, 12.25pt, style=Bold" ShadowOffset="3"
                            Name="Title1" ForeColor="26, 59, 105">
                        </asp:Title>
                    </Titles>
                    <Legends>
                        <asp:Legend TitleFont="Microsoft Sans Serif, 8pt, style=Bold" BackColor="Transparent"
                            Font="Trebuchet MS, 8.25pt, style=Bold" IsTextAutoFit="False" Enabled="False"
                            Name="Default">
                        </asp:Legend>
                    </Legends>
                    <BorderSkin SkinStyle="Emboss"></BorderSkin>
                    <Series>
                        <asp:Series Name="Default">
                        </asp:Series>
                    </Series>
                    <ChartAreas>
                        <asp:ChartArea Name="ChartArea1" BorderColor="64, 64, 64, 64" BackSecondaryColor="White"
                            BackColor="OldLace" ShadowColor="Transparent" BackGradientStyle="TopBottom">
                            <Area3DStyle Rotation="10" Perspective="10" Inclination="15" IsRightAngleAxes="False"
                                WallWidth="0" IsClustered="False" />
                            <AxisY LineColor="64, 64, 64, 64" LabelAutoFitMaxFontSize="8">
                                <LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" Format="C0" />
                                <MajorGrid LineColor="64, 64, 64, 64" />
                            </AxisY>
                            <AxisX LineColor="64, 64, 64, 64" LabelAutoFitMaxFontSize="8">
                                <LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" IsEndLabelVisible="False" Format="MM-dd" />
                                <MajorGrid LineColor="64, 64, 64, 64" />
                            </AxisX>
                        </asp:ChartArea>
                    </ChartAreas>
                </asp:Chart>
                <asp:RadioButtonList runat = "Server" ID="RadioButtonList1" AutoPostBack="True" RepeatDirection=Horizontal >
                    <asp:ListItem Text="Columnas" Value="10" Selected="True"  />
                    <asp:ListItem Text="Barras" Value="7"/>
                    <asp:ListItem Text="Circular" Value="17"/>
                    <asp:ListItem Text="Linea" Value="3"/>                
                </asp:RadioButtonList>
                </td>
                </tr>
                </table>

        </tr>
        <tr>
            <td colspan="2">
               <h2> Cursos recibidos actualmente (Mujeres) <asp:Label ID="Label2" runat="server" Text="Label"></asp:Label></h2>
            <table>
                <tr>
                <td valign="top">
                <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="false">
                    <Columns>
                        <asp:BoundField DataField="detalle" HeaderText="Detalle" />
                        <asp:BoundField DataField="mujeres" HeaderText="Mujeres" DataFormatString="{0:N0}">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>
                        <asp:BoundField DataField="porcentaje" HeaderText="%" DataFormatString="{0:P2}">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>
                    </Columns>
                </asp:GridView>
                </td>
                <td valign="top">
                <asp:Chart ID="Chart3" runat="server" Palette="BrightPastel" BackColor="#F3DFC1"
                    Width="412px" Height="296px" BorderlineDashStyle="Solid" BackGradientStyle="TopBottom"
                    BorderWidth="2" BorderColor="181, 64, 1">
                    <Titles>
                        <asp:Title ShadowColor="32, 0, 0, 0" Font="Trebuchet MS, 12.25pt, style=Bold" ShadowOffset="3"
                            Name="Title1" ForeColor="26, 59, 105">
                        </asp:Title>
                    </Titles>
                    <Legends>
                        <asp:Legend TitleFont="Microsoft Sans Serif, 8pt, style=Bold" BackColor="Transparent"
                            Font="Trebuchet MS, 8.25pt, style=Bold" IsTextAutoFit="False" Enabled="False"
                            Name="Default">
                        </asp:Legend>
                    </Legends>
                    <BorderSkin SkinStyle="Emboss"></BorderSkin>
                    <Series>
                        <asp:Series Name="Default">
                        </asp:Series>
                    </Series>
                    <ChartAreas>
                        <asp:ChartArea Name="ChartArea1" BorderColor="64, 64, 64, 64" BackSecondaryColor="White"
                            BackColor="OldLace" ShadowColor="Transparent" BackGradientStyle="TopBottom">
                            <Area3DStyle Rotation="10" Perspective="10" Inclination="15" IsRightAngleAxes="False"
                                WallWidth="0" IsClustered="False" />
                            <AxisY LineColor="64, 64, 64, 64" LabelAutoFitMaxFontSize="8">
                                <LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" Format="C0" />
                                <MajorGrid LineColor="64, 64, 64, 64" />
                            </AxisY>
                            <AxisX LineColor="64, 64, 64, 64" LabelAutoFitMaxFontSize="8">
                                <LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" IsEndLabelVisible="False" Format="MM-dd" />
                                <MajorGrid LineColor="64, 64, 64, 64" />
                            </AxisX>
                        </asp:ChartArea>
                    </ChartAreas>
                </asp:Chart>
                <asp:RadioButtonList runat = "Server" ID="RadioButtonList2" AutoPostBack="True" RepeatDirection=Horizontal >
                    <asp:ListItem Text="Columnas" Value="10" Selected="True"  />
                    <asp:ListItem Text="Barras" Value="7"/>
                    <asp:ListItem Text="Circular" Value="17"/>
                    <asp:ListItem Text="Linea" Value="3"/>                
                </asp:RadioButtonList>
                </td>
                </tr>
                </table>
            </td>
        </tr>

        <tr>
            <td colspan="2">
               <h2>  Cursos recibidos actualmente (Hombres) <asp:Label ID="Label4" runat="server" Text="Label"></asp:Label></h2>
            <table>
                <tr>
                <td valign="top">
                <asp:GridView ID="GridView4" runat="server" AutoGenerateColumns="false">
                    <Columns>
                        <asp:BoundField DataField="detalle" HeaderText="Detalle" />
                        <asp:BoundField DataField="hombres" HeaderText="Hombres" DataFormatString="{0:N0}">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>
                        <asp:BoundField DataField="porcentaje" HeaderText="%" DataFormatString="{0:P2}">
                            <ItemStyle HorizontalAlign="Right" CssClass="AlineacionDerecha"></ItemStyle>
                        </asp:BoundField>
                    </Columns>
                </asp:GridView>
                </td>
                <td valign="top">
                <asp:Chart ID="Chart4" runat="server" Palette="BrightPastel" BackColor="#F3DFC1"
                    Width="412px" Height="296px" BorderlineDashStyle="Solid" BackGradientStyle="TopBottom"
                    BorderWidth="2" BorderColor="181, 64, 1">
                    <Titles>
                        <asp:Title ShadowColor="32, 0, 0, 0" Font="Trebuchet MS, 12.25pt, style=Bold" ShadowOffset="3"
                            Name="Title1" ForeColor="26, 59, 105">
                        </asp:Title>
                    </Titles>
                    <Legends>
                        <asp:Legend TitleFont="Microsoft Sans Serif, 8pt, style=Bold" BackColor="Transparent"
                            Font="Trebuchet MS, 8.25pt, style=Bold" IsTextAutoFit="False" Enabled="False"
                            Name="Default">
                        </asp:Legend>
                    </Legends>
                    <BorderSkin SkinStyle="Emboss"></BorderSkin>
                    <Series>
                        <asp:Series Name="Default">
                        </asp:Series>
                    </Series>
                    <ChartAreas>
                        <asp:ChartArea Name="ChartArea1" BorderColor="64, 64, 64, 64" BackSecondaryColor="White"
                            BackColor="OldLace" ShadowColor="Transparent" BackGradientStyle="TopBottom">
                            <Area3DStyle Rotation="10" Perspective="10" Inclination="15" IsRightAngleAxes="False"
                                WallWidth="0" IsClustered="False" />
                            <AxisY LineColor="64, 64, 64, 64" LabelAutoFitMaxFontSize="8">
                                <LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" Format="C0" />
                                <MajorGrid LineColor="64, 64, 64, 64" />
                            </AxisY>
                            <AxisX LineColor="64, 64, 64, 64" LabelAutoFitMaxFontSize="8">
                                <LabelStyle Font="Trebuchet MS, 8.25pt, style=Bold" IsEndLabelVisible="False" Format="MM-dd" />
                                <MajorGrid LineColor="64, 64, 64, 64" />
                            </AxisX>
                        </asp:ChartArea>
                    </ChartAreas>
                </asp:Chart>
                <asp:RadioButtonList runat = "Server" ID="RadioButtonList3" AutoPostBack="True" RepeatDirection=Horizontal >
                    <asp:ListItem Text="Columnas" Value="10" Selected="True"  />
                    <asp:ListItem Text="Barras" Value="7"/>
                    <asp:ListItem Text="Circular" Value="17"/>
                    <asp:ListItem Text="Linea" Value="3"/>                
                </asp:RadioButtonList>
                </td>
                </tr>
                </table>
            </td>
        </tr>


        <tr>
        <td>
        <h2>Anexo: Personas que no reciben cursos actualmente (Educación informal)  
            <asp:Label ID="Label3" runat="server" Text="Label"></asp:Label></h2>
            <asp:LinkButton ID="LinkButton1" runat="server" Visible = "true">Exportar anexo a excel</asp:LinkButton>
            <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="true"  Visible = "true" >
            </asp:GridView>
        
            <br />
        
        </td>
        </tr>
        
        
    </table>
    

</asp:Content>
